package com.ruoyi.system.mapper.HUAWEI;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.system.domain.HUAWEI.EmsCustomerSn;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface EmsCustomerSnMapper extends BaseMapper<EmsCustomerSn> {

    @Select("select ISNULL(count(t.task_no),0) sumTaskNo FROM ems_customer_sn t where t.task_no = #{taskTon} and t.part_no=#{productCode}\n" +
            "GROUP BY t.task_no,t.part_no")
    Integer selectByTaskTon(@Param("taskTon") String taskTon, @Param("productCode") String productCode);
}
